Skip to main content

Prerequisites

Before designing a task with HP NonStop SQL/MP as an ODBC Target, the following prerequisites must be met:

  • All source tables and their indexes must already exist on the target database.
  • The default name for the Replicate Apply Exceptions table (attrep_apply_exceptions) is not compliant with HP NonStop SQL/MP table naming conventions which dictate that table names cannot exceed 8 characters or contain non-alphanumeric characters. To resolve this conflict, you need to add the following entry to your NAVMAP file or create a new NAVMAP file (The NAVMAP file is located in the subvolume where ARC is installed):

    Syntax:

    [SQLMP]

    attrep_apply_exceptions= \machine_name.$volume_name.subvolume_name.atreapex

    You also need to manually create the Apply Exceptions table on the HP NonStop SQL/MP target before starting the task. The table should be named atreapex and should contain the following columns:

    Column name data types
    Column name Data type

    TASK_NAME

    Varchar(128)

    TABLE_OWNER

    Varchar(128)

    TABLE_NAME

    Varchar(128)

    ERRORTIME

    Datetime year to fraction

    STATEMENT

    Varchar(1000)

    ERROR

    Varchar(1000)

  • If you intend to enable the Replicate Store Changes option, you need to manually create the audit table on the HP NonStop SQL/MP target before starting the task.

    Information note

    This also requires you make the following changes in the Store Changes Settings tab:

    1. Select Audit table from the Store changes drop-down list.

    2. Change the default audit table name from attrep_audit_table to atreauta.

    Create a table named atreauta with the following parameters:

    Parameter data types
    Column Name Data Type

    *task_name

    Varchar(110)

    *stream_position

    Varchar(128)

    change_seq

    Varchar(35)

    change_oper

    Varchar(1)

    schema_name

    Varchar(128)

    table_name

    Varchar(128)

    operation

    Varchar(12)

    transaction_id

    Varchar(32)

    timestamp

    Timestamp

    change_record

    Varchar(1000)

    bu_change_record

    Varchar(1000)

    Information note

    : You also need to create a Unique Index consisting of the task_name and stream_position columns (marked with an asterisk above).

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!